SongAlbumRecording
Solitude Ellington Indigos 755
   "Rare Broadcast Performances from 1943-1944 1859
   "Hear Them Again! vol 3 2587
   "Billie Holiday on the Net 3811
   "Best of Django Reinhardt, The 4257
   "Savina and All That Gentle Jazz 5556
   "Quintessential Billie Holiday, The (1940-1942) 7035
   "Big Band Feeling, The 7226
   "Daybreak Express 7846
   "Songs You Love to Remember 11672

SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "Solitude"